forum

Home / DeveloperSection / Forums / How to Get a Specific Column Value from a DataTable?

Ask Question

How to Get a Specific Column Value from a DataTable?

Tarun Kumar200724-Feb-2016

I want to fetch a certain column value based on the user input lets say the datatable has two columns ID and CountryName.

I need to find ID in the datatable based on the user input country name. 

please help

c#c# ado.net .net winforms 
Updated on 24-Feb-2016
Tarun Kumar

Tarun Kumar

Follow

Can you answer this question?

Answer

1 Answers

Uttam Misra

Uttam Misra

24-Feb-2016
Here you go:

string Name ="MARK";DataTable dt =newDataTable();int ID=(fromDataRow dr in dt.Rowswhere(string)dr["Name"]== Name select(int)dr["ID"]).FirstOrDefault();

Liked By